DROP TABLE IF EXISTS dim.dim_trade_shops;
CREATE TABLE dim.dim_trade_shops(
    `shopid` int,
    `userid` int,
    `areaid` int,
    `shopname` string,
    `shoplevel` tinyint,
    `status` tinyint,
    `createtime` string,
    `modifytime` string,
    `start_dt` string,
    `end_dt` string
    )
STORED AS PARQUET;